USE Liberty
GO
---------------------------------------------------------------------------------------------------
--	States Population Script
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

IF EXISTS(SELECT 1 FROM dbo.States)
BEGIN
	PRINT 'States already populated; no action taken'
END
ELSE
BEGIN
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'AL', 1, 1 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'AK', 1, 2 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'AS', 1, 3 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'AZ', 1, 4 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'AR', 1, 5 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'CA', 1, 6 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'CO', 1, 7 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'CT', 1, 8 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'DE', 1, 9 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'DC', 1, 10 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'FM', 1, 11 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'FL', 1, 12 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'GA', 1, 13 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'GU', 1, 14 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'HI', 1, 15 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'ID', 1, 16 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'IL', 1, 17 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'IN', 1, 18 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'IA', 1, 19 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'KS', 1, 20 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'KY', 1, 21 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'LA', 1, 22 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'ME', 1, 23 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MH', 1, 24 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MD', 1, 25 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MA', 1, 26 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MI', 1, 27 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MN', 1, 28 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MS', 1, 29 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MO', 1, 30 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MT', 1, 31 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'NE', 1, 32 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'NV', 1, 33 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'NH', 1, 34 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'NJ', 1, 35 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'NM', 1, 36 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'NY', 1, 37 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'NC', 1, 38 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'ND', 1, 39 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'MP', 1, 40 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'OH', 1, 41 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'OK', 1, 42 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'OR', 1, 43 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'PW', 1, 44 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'PA', 1, 45 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'PR', 1, 46 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'RI', 1, 47 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'SC', 1, 48 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'SD', 1, 49 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'TN', 1, 50 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'TX', 1, 51 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'UT', 1, 52 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'VT', 1, 53 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'VI', 1, 54 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'VA', 1, 55 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'WA', 1, 56 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'WV', 1, 57 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'WI', 1, 58 ) 
	INSERT INTO dbo.States ( Description, Active, DisplayOrder ) VALUES( 'WY', 1, 59 ) 

	PRINT 'States has been populated'
END